Summary Report

Author

EPO

Spider Charts for Categories and Action

Overall

Gender

Prefer not to say

Female

None

Male

Age

Young

Middle-aged

Location

Belgium

UK

UK_London

Australia

Second-version of spider charts

Gender

Age

Location

Word-Cloud Open-Ended Question

Sentiment analysis

Emotions

When applied to text for emotion analysis, syuzhet first tokenises the input into words or sentences and then compares each token against a sentiment lexicon (the NRC lexicon in this case) that assigns each word to one or more of eight emotions. It can also produce a single polarity score, positive words increase the score while negative words decrease it, producing an overall numeric polarity value for the text.

NRC works well for short text. While it doesn’t capture intensity (for polarity for example) it also can capture up to eight emotions.

Raw count:

Normalised:

Polarity

Raw Count:

Normalised:

Qualititative Example

The code identifies a representative qualitative response for each classification category using TF-IDF (Term Frequency–Inverse Document Frequency). First, responses are filtered for the relevant sub-questions and cleaned to remove extra spaces and normalise text. Each response is then tokenized into individual words, and TF-IDF is computed for every word, treating each response as a separate document. By summing the TF-IDF scores across all words in a response, we obtain a score that reflects how distinctive and representative that response is within its category. Finally, the response with the highest TF-IDF score in each category is selected as the “Example,” and the total number of unique respondents per category is merged to produce a clean summary table.

Most representative user response per category using TF-IDF
Classification Count Example
peace 11 curtail the russian government and stop their aggression towards other countries
the environment 11 environment
human rights 8 the priority should be freedom by choice. everyone should have the right to choose what they want to do. and this can be made possible by giving options and different opportunities. being obliged to do something is restrictive and can make for an authortarian regime. the freedom of choice can stretch for education to religion, transport, or employement. that is tolerance and not being restricted to not doing what you like because some other people are against it, should never be a problem. give people choice.
social cohesion 7 give humans equal rights, care about everyone’s safety,
education 5 accessible technology
housing 5 they should ensure a decent household for every inhabitants of the city, and guarantee access to basic needs (food, water, electricity)
poverty 5 price of salaries
international peace and stability 4 they need to help countury’s that are in war en make peace on earth
cohesion between people 3 create sustainable migration channels
inequality 3 stop inequalities
living standards 3 mor green
welfare provision 3 mor helping pepole
crime 2 security
health 2 equality, woman rights, reaching the sources, distribution of the sources according to priorities, prioritizing human health and public health
employment 1 be more open to homeless people for jobs so that they don’t have to struggle the same amount they do right now i think it will improve their lives because they get a second chance
local business and employment opportunities 1 they should invest more money in local business and focus on supporting their community
prosperity and growth 1 wealth
safety 1 save the planet
standards of living 1 i think they need to get their shit together and listen to what their citizens want
the economy 1 ensuring economic growth
the economy and prosperity 1 prioritise national interests by trading less with america and china